
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteQuestionnaireItemOptions]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteQuestionnaireItemOptions]
GO

CREATE PROCEDURE [dbo].[DeleteQuestionnaireItemOptions]  (
@itemId	INTEGER = 0
)

AS

BEGIN
	Delete from ItemOption where ItemId = @itemId
	IF @@ERROR <> 0
	BEGIN
		RAISERROR('Unable to delete Questionnaire Item Options', 16, 1)
		RETURN
	END
		
		
END
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

 